#!/bin/bash
#清空mashangdian_db.msc_sso_xxx_join_dinnertable_member表的数据
logfile=/root/logs.txt
echo "" > ${logfile}
for i in `cat /root/zone.txt`
do
mysql -h 103.16.125.27  -uroot -p'mAshang@chi' -e "delete from  mashangdian_db.msc_sso_${i}join_dinnertable_member" > /dev/null 2>&1
if [[ $? -eq  0 ]];then
echo "`date '+%Y-%m-%d_%H.%M'`    OK    ${i}" >> ${logfile}
else
echo "`date '+%Y-%m-%d_%H.%M'`    Fail    ${i}" >>${logfile}
fi
done
